<?php
    include("./dbconn.php");

    $keyword = $_GET['keyword'];

    $sql = "select * from midata where title like '%$keyword%' order by Id limit 0,20";
    
    $result = $conn->query($sql);
    if($result->num_rows > 0){
        for($i =0; $i<$result->num_rows; $i++){
            $list[] = mysqli_fetch_assoc($result);
        }
        $data["code"] = 0;
        $data['list'] = $list;
    }else{
        $data['code'] = 1;
    }
    echo json_encode($data);
?>